How to Duplicate a Table

SQL Tutorial Home

In Oracle you can duplicate a table, but you need to use a different table name. To duplicate the schema and content of a table just do:

create table employee_new as select * from employee;

IN THIS PAGE